package SMS.mapper;

import SMS.pojo.Teachers;
import SMS.vo.ITeacher;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
* @author 王天宇
* @description 针对表【teachers】的数据库操作Mapper
* @createDate 2024-09-16 15:23:09
* @Entity generator.domain.Teachers
*/
@Mapper
public interface TeachersMapper {

    int deleteByPrimaryKey(Long id);

    int insert(Teachers record);

    int insertSelective(Teachers record);

    Teachers selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(Teachers record);

    int updateByPrimaryKey(Teachers record);

    int gettotalCount();

    List<ITeacher> listTeachers(@Param("offset") int offset, @Param("pageSize") int pageSize);

    int countByTeaNo(String req);

    int countByName(String req);

    List<ITeacher> searchTeacherByName(@Param("name") String req, @Param("offset") int offset, @Param("pageSize") int pageSize);

    List<ITeacher> searchTeacherByNo(@Param("teaNo") String req, @Param("offset") int offset, @Param("pageSize") int pageSize);
}
